/*
 Navicat Premium Dump SQL

 Source Server         : docker-mysql
 Source Server Type    : MySQL
 Source Server Version : 50730 (5.7.30-0ubuntu0.18.04.1)
 Source Host           : localhost:3309
 Source Schema         : rvt2ifc

 Target Server Type    : MySQL
 Target Server Version : 50730 (5.7.30-0ubuntu0.18.04.1)
 File Encoding         : 65001

 Date: 10/02/2025 14:52:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `uuid` char(36) NOT NULL COMMENT '文件的唯一标识 UUID',
  `state` smallint(6) NOT NULL COMMENT '0json文件未生成，1json文件已生成',
  `project_name` varchar(255) NOT NULL COMMENT '项目名称',
  `description` text COMMENT '项目描述',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '项目创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='项目表，存储 BIM 项目信息';

-- ----------------------------
-- Records of project
-- ----------------------------
BEGIN;
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (1, '411814650846384128', 3, '热水器2016-2.rvt', '', '2025-02-10 09:24:23');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (2, '411814976206934016', 3, '热水器2016.rvt', '', '2025-02-10 09:25:41');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (3, '411815152116043776', 1, '热水器合并测试', '热水器合并测试', '2025-02-10 09:26:23');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (4, '411817064513146880', 3, '热水器2016.rvt', '', '2025-02-10 09:33:59');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (6, '411819846322360320', 3, 'Y02_301_11_002_建筑结构.rvt', '', '2025-02-10 09:45:02');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (10, '411830299249348608', 3, 'Y02_301_12_001_Ⅰ-B钢网架.rvt', '', '2025-02-10 10:26:34');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (11, '411831044115795968', 1, '钢网架&建筑', '钢网架&建筑', '2025-02-10 10:29:32');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (12, '411835031019851776', 3, 'Y02_301_12_001_钢格栅.rvt', '', '2025-02-10 10:45:22');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (13, '411848872604733440', 3, 'Y02_301_12_001_钢格栅.rvt', '', '2025-02-10 11:40:23');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (14, '411860364943167488', 3, 'Y02_308_00_000_西非机动车棚_20190905.rvt', '', '2025-02-10 12:26:02');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (15, '411860396081680384', 3, 'Y02_300_00_000_厂区工程（管线综合版）.rvt', '', '2025-02-10 12:26:10');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (16, '411860549123444736', 3, 'Y02_301_11_006_建筑结构.rvt', '', '2025-02-10 12:26:46');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (17, '411860593448849408', 3, 'Y02_313_00_000_架空连廊.rvt', '', '2025-02-10 12:26:57');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (18, '411868465608003584', 1, '上海烟厂', '上海烟厂', '2025-02-10 12:58:14');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (19, '411869018937364480', 3, 'Y02_302_11_建筑结构20160107.rvt', '', '2025-02-10 13:00:26');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (20, '411869236592381952', 3, 'Y02_312_00_000_职工车辆大门.rvt', '', '2025-02-10 13:01:18');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (22, '411877918176710656', 3, '热水器2016.rvt', '', '2025-02-10 13:35:48');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (23, '411878199710978048', 3, '热水器2016-2.rvt', '', '2025-02-10 13:36:55');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (24, '411880141505957888', 3, 'Y02_301_工艺设备试验线.rvt', '', '2025-02-10 13:44:38');
INSERT INTO `project` (`id`, `uuid`, `state`, `project_name`, `description`, `created_time`) VALUES (25, '411883696929378304', 1, '上海烟厂2', '上海烟厂2', '2025-02-10 13:58:45');
COMMIT;

-- ----------------------------
-- Table structure for project_mark
-- ----------------------------
DROP TABLE IF EXISTS `project_mark`;
CREATE TABLE `project_mark` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标记唯一标识',
  `uuid` char(36) NOT NULL COMMENT '文件的唯一标识 UUID',
  `project_uuid` char(36) NOT NULL COMMENT '关联的项目 ID',
  `position_x` double NOT NULL COMMENT '标记的 X 坐标',
  `position_y` double NOT NULL COMMENT '标记的 Y 坐标',
  `position_z` double NOT NULL COMMENT '标记的 Z 坐标',
  `view_pos` varchar(255) NOT NULL COMMENT '拾取点时的仕途坐标',
  `entity_id` varchar(255) NOT NULL COMMENT '元素ID，还没搞太清楚',
  `number` varchar(255) NOT NULL COMMENT '编号',
  `title` varchar(255) NOT NULL COMMENT '标记的标题',
  `content` text NOT NULL COMMENT '标记的内容',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '标记创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `project_uuid` (`project_uuid`),
  CONSTRAINT `project_mark_ibfk_1` FOREIGN KEY (`project_uuid`) REFERENCES `project` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='轻量化模型标记表，记录模型中的标记信息';

-- ----------------------------
-- Records of project_mark
-- ----------------------------
BEGIN;
INSERT INTO `project_mark` (`id`, `uuid`, `project_uuid`, `position_x`, `position_y`, `position_z`, `view_pos`, `entity_id`, `number`, `title`, `content`, `created_time`) VALUES (1, '411818590870704128', '411814650846384128', 0.03963044990630982, 5.904729930474222, 5.249280075045851, '{\"eye\":{\"0\":4.149350013459202,\"1\":10.637935742553791,\"2\":8.62707261335463},\"look\":{\"0\":-0.5444243766933865,\"1\":4,\"2\":3.93329822320204},\"up\":{\"0\":-0.5000023975172442,\"1\":0.7071033905688867,\"2\":-0.5000023975172442}}', '2BLmeNKTnDM8ml8pHApKGn', 'A0', '一般', '这是一个标记', '2025-02-10 09:40:03');
INSERT INTO `project_mark` (`id`, `uuid`, `project_uuid`, `position_x`, `position_y`, `position_z`, `view_pos`, `entity_id`, `number`, `title`, `content`, `created_time`) VALUES (2, '411818593081102336', '411814650846384128', -0.03548974599691538, 7.021468055692566, 5.251807299740681, '{\"eye\":{\"0\":4.149350013459202,\"1\":10.637935742553791,\"2\":8.62707261335463},\"look\":{\"0\":-0.5444243766933865,\"1\":4,\"2\":3.93329822320204},\"up\":{\"0\":-0.5000023975172442,\"1\":0.7071033905688867,\"2\":-0.5000023975172442}}', '2BLmeNKTnDM8ml8pHApKGn', 'A1', '一般', '这是一个标记', '2025-02-10 09:40:03');
INSERT INTO `project_mark` (`id`, `uuid`, `project_uuid`, `position_x`, `position_y`, `position_z`, `view_pos`, `entity_id`, `number`, `title`, `content`, `created_time`) VALUES (3, '411836486657249280', '411831044115795968', -121.48671523099068, 13.829295222976562, 22.654554453603133, '{\"eye\":{\"0\":-120.59100747956867,\"1\":14.36516697478025,\"2\":23.396475995623998},\"look\":{\"0\":-135.69010262119343,\"1\":-7.457571130128942,\"2\":7.943095282375494},\"up\":{\"0\":-0.4966366266860639,\"1\":0.7035578297409444,\"2\":-0.5082897217572859}}', '2$JQpZNVf5qRtl4JgEjaNn', 'A0', '一般', '这是一个76876876标记', '2025-02-10 10:51:09');
INSERT INTO `project_mark` (`id`, `uuid`, `project_uuid`, `position_x`, `position_y`, `position_z`, `view_pos`, `entity_id`, `number`, `title`, `content`, `created_time`) VALUES (4, '411836494760644608', '411831044115795968', -121.29958202496887, 13.554346260169138, 22.768676109068267, '{\"eye\":{\"0\":-120.65453157939596,\"1\":14.214027533582131,\"2\":23.668710143677103},\"look\":{\"0\":-135.69010262119343,\"1\":-7.457571130128942,\"2\":7.943095282375494},\"up\":{\"0\":-0.4876999925974143,\"1\":0.7084945452766105,\"2\":-0.5100825389422484}}', '2$JQpZNVf5qRtl4JgEjaNn', 'A1', '一般', '这是一个标记', '2025-02-10 10:51:11');
INSERT INTO `project_mark` (`id`, `uuid`, `project_uuid`, `position_x`, `position_y`, `position_z`, `view_pos`, `entity_id`, `number`, `title`, `content`, `created_time`) VALUES (5, '411836501664468992', '411831044115795968', -123.70594320204773, 12.516785055615149, 21.99548409257579, '{\"eye\":{\"0\":-120.65453157939596,\"1\":14.214027533582131,\"2\":23.668710143677103},\"look\":{\"0\":-135.69010262119343,\"1\":-7.457571130128942,\"2\":7.943095282375494},\"up\":{\"0\":-0.4876999925974143,\"1\":0.7084945452766105,\"2\":-0.5100825389422484}}', '2$JQpZNVf5qRtl4JgEjvSK', 'A2', '一般', '这是一个标记', '2025-02-10 10:51:13');
COMMIT;

-- ----------------------------
-- Table structure for project_model_relation
-- ----------------------------
DROP TABLE IF EXISTS `project_model_relation`;
CREATE TABLE `project_model_relation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `project_uuid` char(36) NOT NULL COMMENT '项目 ID',
  `xkt_model_uuid` char(36) NOT NULL COMMENT '轻量化模型 ID',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '关联创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_uuid` (`project_uuid`,`xkt_model_uuid`),
  KEY `xkt_model_uuid` (`xkt_model_uuid`),
  CONSTRAINT `project_model_relation_ibfk_1` FOREIGN KEY (`project_uuid`) REFERENCES `project` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `project_model_relation_ibfk_2` FOREIGN KEY (`xkt_model_uuid`) REFERENCES `xkt_model` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='项目与轻量化模型的关系表';

-- ----------------------------
-- Records of project_model_relation
-- ----------------------------
BEGIN;
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (1, '411814650846384128', '411814650817024000', '2025-02-10 09:24:23');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (2, '411814976206934016', '411814976194351104', '2025-02-10 09:25:41');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (3, '411815152116043776', '411814976194351104', '2025-02-10 09:26:23');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (4, '411815152116043776', '411814650817024000', '2025-02-10 09:26:23');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (5, '411817064513146880', '411817064504758272', '2025-02-10 09:33:59');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (7, '411819846322360320', '411819846305583104', '2025-02-10 09:45:02');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (12, '411830299249348608', '411830299240960000', '2025-02-10 10:26:34');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (13, '411831044115795968', '411819846305583104', '2025-02-10 10:29:32');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (14, '411831044115795968', '411830299240960000', '2025-02-10 10:29:32');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (15, '411835031019851776', '411835030994685952', '2025-02-10 10:45:22');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (16, '411848872604733440', '411848872587956224', '2025-02-10 11:40:23');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (17, '411860364943167488', '411860364926390272', '2025-02-10 12:26:03');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (18, '411860396081680384', '411860396069097472', '2025-02-10 12:26:10');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (19, '411860549123444736', '411860549106667520', '2025-02-10 12:26:46');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (20, '411860593448849408', '411860593436266496', '2025-02-10 12:26:57');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (21, '411868465608003584', '411819846305583104', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (22, '411868465608003584', '411830299240960000', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (23, '411868465608003584', '411860364926390272', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (24, '411868465608003584', '411860396069097472', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (25, '411868465608003584', '411860549106667520', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (26, '411868465608003584', '411860593436266496', '2025-02-10 12:58:14');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (27, '411869018937364480', '411869018924781568', '2025-02-10 13:00:26');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (28, '411869236592381952', '411869236575604736', '2025-02-10 13:01:18');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (30, '411877918176710656', '411877918164127744', '2025-02-10 13:35:48');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (31, '411878199710978048', '411878199694200832', '2025-02-10 13:36:55');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (32, '411880141505957888', '411880141484986368', '2025-02-10 13:44:38');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (33, '411883696929378304', '411819846305583104', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (34, '411883696929378304', '411830299240960000', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (35, '411883696929378304', '411860364926390272', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (36, '411883696929378304', '411860396069097472', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (37, '411883696929378304', '411860549106667520', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (38, '411883696929378304', '411860593436266496', '2025-02-10 13:58:45');
INSERT INTO `project_model_relation` (`id`, `project_uuid`, `xkt_model_uuid`, `created_time`) VALUES (39, '411883696929378304', '411880141484986368', '2025-02-10 13:58:45');
COMMIT;

-- ----------------------------
-- Table structure for uploaded_file
-- ----------------------------
DROP TABLE IF EXISTS `uploaded_file`;
CREATE TABLE `uploaded_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `uuid` char(36) NOT NULL COMMENT '文件的唯一标识 UUID',
  `file_name` varchar(255) NOT NULL COMMENT '文件原始名称',
  `pinyin_name` varchar(255) NOT NULL COMMENT '拼音名',
  `file_size` bigint(20) NOT NULL COMMENT '文件大小（字节）',
  `stored_name` varchar(255) NOT NULL COMMENT '存储的文件名',
  `upload_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上传时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='记录用户上传的文件信息';

-- ----------------------------
-- Records of uploaded_file
-- ----------------------------
BEGIN;
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (2, '411814650796052480', '热水器2016-2.rvt', 'reshuiqi2016-2.rvt', 8450048, '411814650770886656.rvt', '2025-02-10 09:24:23');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (3, '411814976156602368', '热水器2016.rvt', 'reshuiqi2016.rvt', 8654848, '411814976127242240.rvt', '2025-02-10 09:25:41');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (4, '411817064454426624', '热水器2016.rvt', 'reshuiqi2016.rvt', 8654848, '411817064446038016.rvt', '2025-02-10 09:33:59');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (5, '411819757180817408', '堆场实验装置_202404091627.rvt', 'duichangshiyanzhuangzhi_202404091627.rvt', 58339328, '411819757147262976.rvt', '2025-02-10 09:44:41');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (6, '411819846280417280', 'Y02_301_11_002_建筑结构.rvt', 'Y02_301_11_002_jianzhujiegou.rvt', 118546432, '411819846276222976.rvt', '2025-02-10 09:45:02');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (7, '411820857007017984', 'Y02_301_12_001_钢格栅.rvt', 'Y02_301_12_001_ganggezha.rvt', 11091968, '411820856998629376.rvt', '2025-02-10 09:49:03');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (8, '411825253153509376', 'Y02_301_12_001_Ⅰ-B钢网架.rvt', 'Y02_301_12_001_Ⅰ-Bgangwangjia.rvt', 49831936, '411825253132537856.rvt', '2025-02-10 10:06:31');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (9, '411830299207405568', 'Y02_301_12_001_Ⅰ-B钢网架.rvt', 'Y02_301_12_001_Ⅰ-Bgangwangjia.rvt', 49831936, '411830299173851136.rvt', '2025-02-10 10:26:34');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (10, '411835030948548608', 'Y02_301_12_001_钢格栅.rvt', 'Y02_301_12_001_ganggezha.rvt', 11091968, '411835030940160000.rvt', '2025-02-10 10:45:22');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (11, '411848872533430272', 'Y02_301_12_001_钢格栅.rvt', 'Y02_301_12_001_ganggezha.rvt', 11091968, '411848872525041664.rvt', '2025-02-10 11:40:22');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (12, '411860364876058624', 'Y02_308_00_000_西非机动车棚_20190905.rvt', 'Y02_308_00_000_xifeijidongchepeng_20190905.rvt', 15654912, '411860364846698496.rvt', '2025-02-10 12:26:02');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (13, '411860396039737344', 'Y02_300_00_000_厂区工程（管线综合版）.rvt', 'Y02_300_00_000_changqugongcheng（guanxianzongheban）.rvt', 75333632, '411860396018765824.rvt', '2025-02-10 12:26:10');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (14, '411860549052141568', 'Y02_301_11_006_建筑结构.rvt', 'Y02_301_11_006_jianzhujiegou.rvt', 223903744, '411860549043752960.rvt', '2025-02-10 12:26:46');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (15, '411860593406906368', 'Y02_313_00_000_架空连廊.rvt', 'Y02_313_00_000_jiakonglianlang.rvt', 24211456, '411860593402712064.rvt', '2025-02-10 12:26:57');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (16, '411869018853478400', 'Y02_302_11_建筑结构20160107.rvt', 'Y02_302_11_jianzhujiegou20160107.rvt', 98177024, '411869018840895488.rvt', '2025-02-10 13:00:26');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (17, '411869236504301568', 'Y02_312_00_000_职工车辆大门.rvt', 'Y02_312_00_000_zhigongcheliangdamen.rvt', 19304448, '411869236491718656.rvt', '2025-02-10 13:01:18');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (18, '411870562890027008', 'Y02_301_工艺设备试验线.rvt', 'Y02_301_gongyishebeishiyanxian.rvt', 1549905920, '411870562818723840.rvt', '2025-02-10 13:06:34');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (19, '411877918126379008', '热水器2016.rvt', 'reshuiqi2016.rvt', 8654848, '411877918063464448.rvt', '2025-02-10 13:35:48');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (20, '411878199652257792', '热水器2016-2.rvt', 'reshuiqi2016-2.rvt', 8450048, '411878199648063488.rvt', '2025-02-10 13:36:55');
INSERT INTO `uploaded_file` (`id`, `uuid`, `file_name`, `pinyin_name`, `file_size`, `stored_name`, `upload_time`) VALUES (21, '411880141426266112', 'Y02_301_工艺设备试验线.rvt', 'Y02_301_gongyishebeishiyanxian.rvt', 1549905920, '411880141333991424.rvt', '2025-02-10 13:44:38');
COMMIT;

-- ----------------------------
-- Table structure for xkt_model
-- ----------------------------
DROP TABLE IF EXISTS `xkt_model`;
CREATE TABLE `xkt_model` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `uuid` char(36) NOT NULL COMMENT '文件的唯一标识 UUID',
  `uploaded_file_uuid` char(36) NOT NULL COMMENT '关联的 RVT 文件 ID',
  `state` smallint(6) NOT NULL COMMENT '0待转换，1转换完成，2转换中,3转换失败',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '轻量化模型创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `uploaded_file_uuid` (`uploaded_file_uuid`),
  CONSTRAINT `xkt_model_ibfk_1` FOREIGN KEY (`uploaded_file_uuid`) REFERENCES `uploaded_file` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='轻量化模型表，存储导出的 metadata.json 和 geometry.xkt 文件信息';

-- ----------------------------
-- Records of xkt_model
-- ----------------------------
BEGIN;
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (1, '411814650817024000', '411814650796052480', 1, '2025-02-10 09:24:23');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (2, '411814976194351104', '411814976156602368', 1, '2025-02-10 09:25:41');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (3, '411817064504758272', '411817064454426624', 1, '2025-02-10 09:33:59');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (4, '411819757214371840', '411819757180817408', 1, '2025-02-10 09:44:41');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (5, '411819846305583104', '411819846280417280', 1, '2025-02-10 09:45:02');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (6, '411820857040572416', '411820857007017984', 1, '2025-02-10 09:49:03');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (7, '411825253291921408', '411825253153509376', 1, '2025-02-10 10:06:31');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (8, '411830299240960000', '411830299207405568', 1, '2025-02-10 10:26:34');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (9, '411835030994685952', '411835030948548608', 1, '2025-02-10 10:45:22');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (10, '411848872587956224', '411848872533430272', 1, '2025-02-10 11:40:23');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (11, '411860364926390272', '411860364876058624', 1, '2025-02-10 12:26:02');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (12, '411860396069097472', '411860396039737344', 1, '2025-02-10 12:26:10');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (13, '411860549106667520', '411860549052141568', 1, '2025-02-10 12:26:46');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (14, '411860593436266496', '411860593406906368', 1, '2025-02-10 12:26:57');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (15, '411869018924781568', '411869018853478400', 1, '2025-02-10 13:00:26');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (16, '411869236575604736', '411869236504301568', 1, '2025-02-10 13:01:18');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (17, '411870562961330176', '411870562890027008', 0, '2025-02-10 13:06:34');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (18, '411877918164127744', '411877918126379008', 1, '2025-02-10 13:35:48');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (19, '411878199694200832', '411878199652257792', 1, '2025-02-10 13:36:55');
INSERT INTO `xkt_model` (`id`, `uuid`, `uploaded_file_uuid`, `state`, `created_time`) VALUES (20, '411880141484986368', '411880141426266112', 1, '2025-02-10 13:44:38');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
